package kuanshu.mapper;


import kuanshu.bean.FangDongXinXi;
import kuanshu.bean.FangWuJiBenXinXi;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface FangDongXinXiMapper {

@Select("SELECT b.* FROM yonghuxinxi b")
List<FangDongXinXi> find();

@Insert("insert into `FangDongXinXi` values(#{fangdongID},#{yonghuzhanghao},#{fangdongbianhao},#{zhenshixingming},#{xingbie},#{shoujihaoma},#{dianziyouxiang},#{shenfenzhenghao},#{chushengriqi},#{shenfenzhengzhengmianzhao},#{shenfenzhengfanmianzhao},#{yinhangkahao},#{fangwudangqianzhuangtai})")
int tianjia(FangDongXinXi fangdongxinxi);

    @Select("select * from fangdongxinxi")
    List<FangDongXinXi> chakan();
}


